Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 117304 |
| Missing cells | 457182 |
| Missing cells (%) | 22.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 15.2 MiB |
| Average record size in memory | 136.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 6 |
| DateTime | 2 |
dim_comment has constant value "" | Constant |
id_external has a high cardinality: 117185 distinct values | High cardinality |
dim_name has a high cardinality: 1799 distinct values | High cardinality |
id_store is highly overall correlated with id_table and 1 other fields | High correlation |
id_table is highly overall correlated with id_store and 3 other fields | High correlation |
id_waiter is highly overall correlated with id_store and 3 other fields | High correlation |
id_customer is highly overall correlated with id_table | High correlation |
id_device is highly overall correlated with id_table and 1 other fields | High correlation |
m_cached_payed is highly overall correlated with m_cached_price | High correlation |
m_cached_price is highly overall correlated with m_cached_payed | High correlation |
dim_status is highly overall correlated with dim_source | High correlation |
dim_type is highly overall correlated with id_waiter | High correlation |
dim_source is highly overall correlated with id_waiter and 2 other fields | High correlation |
dim_status is highly imbalanced (97.0%) | Imbalance |
dim_type is highly imbalanced (> 99.9%) | Imbalance |
id_table has 95387 (81.3%) missing values | Missing |
id_waiter has 59927 (51.1%) missing values | Missing |
id_customer has 115437 (98.4%) missing values | Missing |
id_device has 8398 (7.2%) missing values | Missing |
dim_name has 60751 (51.8%) missing values | Missing |
dim_comment has 117210 (99.9%) missing values | Missing |
m_cached_payed is highly skewed (γ1 = 20.40843559) | Skewed |
m_cached_price is highly skewed (γ1 = 20.41067901) | Skewed |
id_external is uniformly distributed | Uniform |
id_order has unique values | Unique |
Reproduction
| Analysis started | 2023-11-08 14:28:58.754306 |
|---|---|
| Analysis finished | 2023-11-08 14:29:21.339023 |
| Duration | 22.58 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
id_order
Real number (ℝ)
| Distinct | 117304 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90489232 |
| Minimum | 54304217 |
|---|---|
| Maximum | 1.5052558 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 54304217 |
|---|---|
| 5-th percentile | 57018624 |
| Q1 | 68975726 |
| median | 85227102 |
| Q3 | 1.0915759 × 108 |
| 95-th percentile | 1.3966136 × 108 |
| Maximum | 1.5052558 × 108 |
| Range | 96221365 |
| Interquartile range (IQR) | 40181861 |
Descriptive statistics
| Standard deviation | 25346971 |
|---|---|
| Coefficient of variation (CV) | 0.28011035 |
| Kurtosis | -0.75114091 |
| Mean | 90489232 |
| Median Absolute Deviation (MAD) | 18964352 |
| Skewness | 0.52363833 |
| Sum | 1.0614749 × 1013 |
| Variance | 6.4246893 × 1014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 55538867 | 1 | < 0.1% |
| 98394465 | 1 | < 0.1% |
| 141379937 | 1 | < 0.1% |
| 137955892 | 1 | < 0.1% |
| 81456389 | 1 | < 0.1% |
| 80582874 | 1 | < 0.1% |
| 80224543 | 1 | < 0.1% |
| 146010386 | 1 | < 0.1% |
| 137143248 | 1 | < 0.1% |
| 98452252 | 1 | < 0.1% |
| Other values (117294) | 117294 |
| Value | Count | Frequency (%) |
| 54304217 | 1 | |
| 54304720 | 1 | |
| 54305289 | 1 | |
| 54305380 | 1 | |
| 54308504 | 1 | |
| 54308574 | 1 | |
| 54308595 | 1 | |
| 54308598 | 1 | |
| 54315725 | 1 | |
| 54316003 | 1 |
| Value | Count | Frequency (%) |
| 150525582 | 1 | |
| 150524077 | 1 | |
| 150520714 | 1 | |
| 150520444 | 1 | |
| 150519879 | 1 | |
| 150519354 | 1 | |
| 150508884 | 1 | |
| 150506690 | 1 | |
| 150505612 | 1 | |
| 150501875 | 1 |
id_store
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4984.8651 |
| Minimum | 360 |
|---|---|
| Maximum | 9084 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 360 |
|---|---|
| 5-th percentile | 1796 |
| Q1 | 1796 |
| median | 4542 |
| Q3 | 7965 |
| 95-th percentile | 9084 |
| Maximum | 9084 |
| Range | 8724 |
| Interquartile range (IQR) | 6169 |
Descriptive statistics
| Standard deviation | 2575.8883 |
|---|---|
| Coefficient of variation (CV) | 0.51674183 |
| Kurtosis | -1.1749142 |
| Mean | 4984.8651 |
| Median Absolute Deviation (MAD) | 2746 |
| Skewness | -0.0060064917 |
| Sum | 5.8474462 × 108 |
| Variance | 6635200.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 1796 | 27349 | |
| 4337 | 20003 | |
| 4542 | 17641 | |
| 6293 | 16103 | |
| 8283 | 10023 | 8.5% |
| 7965 | 9091 | 7.7% |
| 9084 | 7804 | 6.7% |
| 8052 | 4906 | 4.2% |
| 360 | 4383 | 3.7% |
| 8347 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 360 | 4383 | 3.7% |
| 1796 | 27349 | |
| 4337 | 20003 | |
| 4542 | 17641 | |
| 6293 | 16103 | |
| 7965 | 9091 | 7.7% |
| 8052 | 4906 | 4.2% |
| 8283 | 10023 | 8.5% |
| 8347 | 1 | < 0.1% |
| 9084 | 7804 | 6.7% |
| Value | Count | Frequency (%) |
| 9084 | 7804 | 6.7% |
| 8347 | 1 | < 0.1% |
| 8283 | 10023 | 8.5% |
| 8052 | 4906 | 4.2% |
| 7965 | 9091 | 7.7% |
| 6293 | 16103 | |
| 4542 | 17641 | |
| 4337 | 20003 | |
| 1796 | 27349 | |
| 360 | 4383 | 3.7% |
id_table
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 97 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 95387 |
| Missing (%) | 81.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 152108.64 |
| Minimum | 3199 |
|---|---|
| Maximum | 288083 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 3199 |
|---|---|
| 5-th percentile | 3202 |
| Q1 | 113481 |
| median | 166328 |
| Q3 | 198340 |
| 95-th percentile | 265242 |
| Maximum | 288083 |
| Range | 284884 |
| Interquartile range (IQR) | 84859 |
Descriptive statistics
| Standard deviation | 75645.829 |
|---|---|
| Coefficient of variation (CV) | 0.49731447 |
| Kurtosis | 0.019984883 |
| Mean | 152108.64 |
| Median Absolute Deviation (MAD) | 32013 |
| Skewness | -0.89992451 |
| Sum | 3.3337651 × 109 |
| Variance | 5.7222915 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 113481 | 689 | 0.6% |
| 3199 | 621 | 0.5% |
| 166322 | 613 | 0.5% |
| 206103 | 598 | 0.5% |
| 198339 | 594 | 0.5% |
| 206096 | 576 | 0.5% |
| 206102 | 536 | 0.5% |
| 184593 | 500 | 0.4% |
| 166314 | 499 | 0.4% |
| 184589 | 451 | 0.4% |
| Other values (87) | 16240 | 13.8% |
| (Missing) | 95387 |
| Value | Count | Frequency (%) |
| 3199 | 621 | |
| 3200 | 278 | |
| 3201 | 165 | 0.1% |
| 3202 | 153 | 0.1% |
| 3203 | 133 | 0.1% |
| 3204 | 334 | |
| 3205 | 398 | |
| 3206 | 351 | |
| 3207 | 406 | |
| 3208 | 189 | 0.2% |
| Value | Count | Frequency (%) |
| 288083 | 30 | < 0.1% |
| 288082 | 26 | < 0.1% |
| 288081 | 36 | < 0.1% |
| 288080 | 54 | < 0.1% |
| 288078 | 91 | 0.1% |
| 288075 | 120 | |
| 288074 | 263 | |
| 288073 | 287 | |
| 265242 | 215 | |
| 244837 | 182 |
id_waiter
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 59927 |
| Missing (%) | 51.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8236.9124 |
| Minimum | 472 |
|---|---|
| Maximum | 18911 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 472 |
|---|---|
| 5-th percentile | 472 |
| Q1 | 2418 |
| median | 2418 |
| Q3 | 16793 |
| 95-th percentile | 18911 |
| Maximum | 18911 |
| Range | 18439 |
| Interquartile range (IQR) | 14375 |
Descriptive statistics
| Standard deviation | 6996.0912 |
|---|---|
| Coefficient of variation (CV) | 0.84935845 |
| Kurtosis | -1.5139972 |
| Mean | 8236.9124 |
| Median Absolute Deviation (MAD) | 1946 |
| Skewness | 0.49543935 |
| Sum | 4.7260932 × 108 |
| Variance | 48945292 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 2418 | 24667 | |
| 16793 | 10023 | 8.5% |
| 7588 | 9152 | 7.8% |
| 18911 | 7804 | 6.7% |
| 472 | 4129 | 3.5% |
| 15977 | 1087 | 0.9% |
| 16199 | 507 | 0.4% |
| 11585 | 8 | < 0.1% |
| (Missing) | 59927 |
| Value | Count | Frequency (%) |
| 472 | 4129 | 3.5% |
| 2418 | 24667 | |
| 7588 | 9152 | 7.8% |
| 11585 | 8 | < 0.1% |
| 15977 | 1087 | 0.9% |
| 16199 | 507 | 0.4% |
| 16793 | 10023 | |
| 18911 | 7804 | 6.7% |
| Value | Count | Frequency (%) |
| 18911 | 7804 | 6.7% |
| 16793 | 10023 | |
| 16199 | 507 | 0.4% |
| 15977 | 1087 | 0.9% |
| 11585 | 8 | < 0.1% |
| 7588 | 9152 | 7.8% |
| 2418 | 24667 | |
| 472 | 4129 | 3.5% |
id_customer
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 833 |
|---|---|
| Distinct (%) | 44.6% |
| Missing | 115437 |
| Missing (%) | 98.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1904322.7 |
| Minimum | 1206843 |
|---|---|
| Maximum | 2783146 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 1206843 |
|---|---|
| 5-th percentile | 1638954 |
| Q1 | 1653653 |
| median | 1843156 |
| Q3 | 2126142 |
| 95-th percentile | 2355539 |
| Maximum | 2783146 |
| Range | 1576303 |
| Interquartile range (IQR) | 472489 |
Descriptive statistics
| Standard deviation | 277784.24 |
|---|---|
| Coefficient of variation (CV) | 0.14587036 |
| Kurtosis | -0.36494318 |
| Mean | 1904322.7 |
| Median Absolute Deviation (MAD) | 197470 |
| Skewness | 0.46261792 |
| Sum | 3.5553706 × 109 |
| Variance | 7.7164085 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1647303 | 46 | < 0.1% |
| 1646350 | 41 | < 0.1% |
| 1642601 | 39 | < 0.1% |
| 1644184 | 36 | < 0.1% |
| 1647065 | 34 | < 0.1% |
| 1647698 | 33 | < 0.1% |
| 1668408 | 31 | < 0.1% |
| 1652738 | 28 | < 0.1% |
| 1638954 | 27 | < 0.1% |
| 1654937 | 25 | < 0.1% |
| Other values (823) | 1527 | 1.3% |
| (Missing) | 115437 |
| Value | Count | Frequency (%) |
| 1206843 | 1 | < 0.1% |
| 1220796 | 1 | < 0.1% |
| 1221186 | 2 | |
| 1221743 | 1 | < 0.1% |
| 1240617 | 1 | < 0.1% |
| 1247531 | 1 | < 0.1% |
| 1249747 | 1 | < 0.1% |
| 1250394 | 3 | |
| 1251295 | 1 | < 0.1% |
| 1251359 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2783146 | 1 | |
| 2778917 | 1 | |
| 2765702 | 1 | |
| 2760654 | 1 | |
| 2757354 | 1 | |
| 2756847 | 1 | |
| 2737762 | 1 | |
| 2729843 | 1 | |
| 2722728 | 1 | |
| 2716470 | 2 |
id_external
Categorical
HIGH CARDINALITY UNIFORM
| Distinct | 117185 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 72 |
| Missing (%) | 0.1% |
| Memory size | 916.6 KiB |
| b6f1b0aa-dbed-4130-8691-631d301445b0 | 3 |
|---|---|
| a03e0170-8b58-48f4-aaf6-17e7b7f3ffe5 | 3 |
| 772162b4-5447-4be2-857e-173a039c6ffc | 3 |
| 8e555d4c-fd01-45d5-96b9-31b96954c2a3 | 2 |
| e6855374-1ea4-4cab-9e90-c1fdd36f56b9 | 2 |
| Other values (117180) |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 35.976747 |
| Min length | 7 |
Characters and Unicode
| Total characters | 4217626 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 117141 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | 0425716B-EFF4-41CA-AEA1-839104F36833 |
|---|---|
| 2nd row | 75E41FE2-64FF-41D3-954C-A7DE4AA887EF |
| 3rd row | F6051A05-C9AC-4033-BF72-BB5149B8F439 |
| 4th row | B8BEEC66-1C10-48A0-B4D5-035CB5EEFE62 |
| 5th row | 17F0533C-2FF1-4FC5-A50D-12704C7B7A4B |
Common Values
| Value | Count | Frequency (%) |
| b6f1b0aa-dbed-4130-8691-631d301445b0 | 3 | < 0.1% |
| a03e0170-8b58-48f4-aaf6-17e7b7f3ffe5 | 3 | < 0.1% |
| 772162b4-5447-4be2-857e-173a039c6ffc | 3 | < 0.1% |
| 8e555d4c-fd01-45d5-96b9-31b96954c2a3 | 2 | < 0.1% |
| e6855374-1ea4-4cab-9e90-c1fdd36f56b9 | 2 | < 0.1% |
| a7de716f-6684-485e-b012-9a3914bf59a0 | 2 | < 0.1% |
| 81e09f6c-3c7d-4a62-89ad-76d91592688f | 2 | < 0.1% |
| ca97b0d1-b74e-426a-8347-9c9478c834ce | 2 | < 0.1% |
| 374ad4c6-d8f6-4aa6-871f-4205af7f153e | 2 | < 0.1% |
| d0d99bed-ffc6-4fd5-a31b-eb14cb6ff5c5 | 2 | < 0.1% |
| Other values (117175) | 117209 | |
| (Missing) | 72 | 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| b6f1b0aa-dbed-4130-8691-631d301445b0 | 3 | < 0.1% |
| 772162b4-5447-4be2-857e-173a039c6ffc | 3 | < 0.1% |
| a03e0170-8b58-48f4-aaf6-17e7b7f3ffe5 | 3 | < 0.1% |
| 4d9acc25-3b88-43cf-b437-153e414d9a09 | 2 | < 0.1% |
| 7e875325-4e25-44c7-a3d1-89d65a3cf6bd | 2 | < 0.1% |
| 20d595cf-9e7b-4308-af37-d38292ec2617 | 2 | < 0.1% |
| 02404df3-9617-4618-9ef0-5c52e64a4dcb | 2 | < 0.1% |
| aeb3a3f6-02e3-4061-aa4b-bc37ea187980 | 2 | < 0.1% |
| fdc4cd2c-a0c1-496a-aadc-297e2a023e5f | 2 | < 0.1% |
| bd1662da-6fea-41ed-81b1-22919fc098b1 | 2 | < 0.1% |
| Other values (117175) | 117209 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 468552 | 11.1% |
| 4 | 336376 | 8.0% |
| 9 | 249462 | 5.9% |
| B | 248814 | 5.9% |
| 8 | 248531 | 5.9% |
| A | 247423 | 5.9% |
| 6 | 220732 | 5.2% |
| 7 | 220173 | 5.2% |
| 0 | 219970 | 5.2% |
| 2 | 219747 | 5.2% |
| Other values (13) | 1537846 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2373398 | |
| Uppercase Letter | 1371838 | |
| Dash Punctuation | 468552 | 11.1% |
| Lowercase Letter | 3838 | 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 336376 | |
| 9 | 249462 | |
| 8 | 248531 | |
| 6 | 220732 | |
| 7 | 220173 | |
| 0 | 219970 | |
| 2 | 219747 | |
| 1 | 219610 | |
| 3 | 219531 | |
| 5 | 219266 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 248814 | |
| A | 247423 | |
| D | 219558 | |
| C | 219178 | |
| E | 218555 | |
| F | 218310 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 678 | |
| a | 669 | |
| d | 641 | |
| c | 632 | |
| f | 612 | |
| e | 606 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 468552 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2841950 | |
| Latin | 1375676 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 248814 | |
| A | 247423 | |
| D | 219558 | |
| C | 219178 | |
| E | 218555 | |
| F | 218310 | |
| b | 678 | < 0.1% |
| a | 669 | < 0.1% |
| d | 641 | < 0.1% |
| c | 632 | < 0.1% |
| Other values (2) | 1218 | 0.1% |
Common
| Value | Count | Frequency (%) |
| - | 468552 | |
| 4 | 336376 | |
| 9 | 249462 | |
| 8 | 248531 | |
| 6 | 220732 | |
| 7 | 220173 | |
| 0 | 219970 | |
| 2 | 219747 | |
| 1 | 219610 | |
| 3 | 219531 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4217626 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 468552 | 11.1% |
| 4 | 336376 | 8.0% |
| 9 | 249462 | 5.9% |
| B | 248814 | 5.9% |
| 8 | 248531 | 5.9% |
| A | 247423 | 5.9% |
| 6 | 220732 | 5.2% |
| 7 | 220173 | 5.2% |
| 0 | 219970 | 5.2% |
| 2 | 219747 | 5.2% |
| Other values (13) | 1537846 |
id_device
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 8398 |
| Missing (%) | 7.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11238.598 |
| Minimum | 129 |
|---|---|
| Maximum | 17755 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 129 |
|---|---|
| 5-th percentile | 6694 |
| Q1 | 7411 |
| median | 10820 |
| Q3 | 15733 |
| 95-th percentile | 17755 |
| Maximum | 17755 |
| Range | 17626 |
| Interquartile range (IQR) | 8322 |
Descriptive statistics
| Standard deviation | 4577.8719 |
|---|---|
| Coefficient of variation (CV) | 0.4073348 |
| Kurtosis | -0.67123007 |
| Mean | 11238.598 |
| Median Absolute Deviation (MAD) | 4126 |
| Skewness | -0.19810361 |
| Sum | 1.2239507 × 109 |
| Variance | 20956911 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 6694 | 19838 | |
| 7411 | 17641 | |
| 11882 | 16103 | |
| 10820 | 14284 | |
| 17755 | 9139 | |
| 15161 | 9091 | |
| 15733 | 5267 | 4.5% |
| 17320 | 5173 | 4.4% |
| 16813 | 4733 | 4.0% |
| 129 | 4057 | 3.5% |
| Other values (3) | 3580 | 3.1% |
| (Missing) | 8398 |
| Value | Count | Frequency (%) |
| 129 | 4057 | 3.5% |
| 6694 | 19838 | |
| 7411 | 17641 | |
| 10820 | 14284 | |
| 11882 | 16103 | |
| 15161 | 9091 | |
| 15327 | 172 | 0.1% |
| 15733 | 5267 | 4.5% |
| 15894 | 1 | < 0.1% |
| 16813 | 4733 | 4.0% |
| Value | Count | Frequency (%) |
| 17755 | 9139 | |
| 17383 | 3407 | 2.9% |
| 17320 | 5173 | 4.4% |
| 16813 | 4733 | 4.0% |
| 15894 | 1 | < 0.1% |
| 15733 | 5267 | 4.5% |
| 15327 | 172 | 0.1% |
| 15161 | 9091 | |
| 11882 | 16103 | |
| 10820 | 14284 |
date_opened
Date
| Distinct | 116676 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 916.6 KiB |
| Minimum | 2019-01-01 01:23:18+00:00 |
|---|---|
| Maximum | 2020-11-18 18:53:33+00:00 |
Histogram with fixed size bins (bins=50)
date_closed
Date
| Distinct | 116751 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 916.6 KiB |
| Minimum | 2019-01-01 01:23:25+00:00 |
|---|---|
| Maximum | 2020-11-18 18:54:42+00:00 |
Histogram with fixed size bins (bins=50)
dim_name
Categorical
HIGH CARDINALITY MISSING
| Distinct | 1799 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 60751 |
| Missing (%) | 51.8% |
| Memory size | 916.6 KiB |
| A1 | 740 |
|---|---|
| A2 | 724 |
| A3 | 712 |
| A4 | 695 |
| A5 | 669 |
| Other values (1794) |
Length
| Max length | 31 |
|---|---|
| Median length | 3 |
| Mean length | 3.0695277 |
| Min length | 1 |
Characters and Unicode
| Total characters | 173591 |
|---|---|
| Distinct characters | 87 |
| Distinct categories | 13 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 7 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 977 ? |
|---|---|
| Unique (%) | 1.7% |
Sample
| 1st row | vincent |
|---|---|
| 2nd row | frere et soeur avec pierre |
| 3rd row | rachel |
| 4th row | Groupe PEL |
| 5th row | remi et date |
Common Values
| Value | Count | Frequency (%) |
| A1 | 740 | 0.6% |
| A2 | 724 | 0.6% |
| A3 | 712 | 0.6% |
| A4 | 695 | 0.6% |
| A5 | 669 | 0.6% |
| A6 | 661 | 0.6% |
| A7 | 649 | 0.6% |
| A8 | 641 | 0.5% |
| A9 | 625 | 0.5% |
| A10 | 618 | 0.5% |
| Other values (1789) | 49819 | |
| (Missing) | 60751 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| a1 | 741 | 1.3% |
| a2 | 724 | 1.2% |
| a3 | 712 | 1.2% |
| a4 | 696 | 1.2% |
| a5 | 669 | 1.1% |
| a6 | 661 | 1.1% |
| a7 | 649 | 1.1% |
| a8 | 641 | 1.1% |
| a9 | 625 | 1.1% |
| a10 | 618 | 1.1% |
| Other values (1699) | 51765 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 20477 | 11.8% |
| 1 | 19178 | 11.0% |
| 2 | 14592 | 8.4% |
| K | 12119 | 7.0% |
| 3 | 11359 | 6.5% |
| 4 | 9857 | 5.7% |
| N | 9147 | 5.3% |
| 5 | 8767 | 5.1% |
| B | 8255 | 4.8% |
| 6 | 7658 | 4.4% |
| Other values (77) | 52182 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 94166 | |
| Uppercase Letter | 54528 | |
| Lowercase Letter | 21781 | 12.5% |
| Space Separator | 2084 | 1.2% |
| Other Punctuation | 453 | 0.3% |
| Dash Punctuation | 310 | 0.2% |
| Open Punctuation | 106 | 0.1% |
| Close Punctuation | 105 | 0.1% |
| Math Symbol | 39 | < 0.1% |
| Other Symbol | 9 | < 0.1% |
| Other values (3) | 10 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2989 | |
| a | 2813 | |
| r | 2133 | |
| t | 1748 | 8.0% |
| i | 1445 | 6.6% |
| o | 1292 | 5.9% |
| l | 1285 | 5.9% |
| u | 1206 | 5.5% |
| c | 1161 | 5.3% |
| n | 1050 | 4.8% |
| Other values (21) | 4659 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 20477 | |
| K | 12119 | |
| N | 9147 | |
| B | 8255 | |
| L | 3754 | 6.9% |
| F | 329 | 0.6% |
| M | 119 | 0.2% |
| D | 104 | 0.2% |
| E | 36 | 0.1% |
| I | 23 | < 0.1% |
| Other values (16) | 165 | 0.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 19178 | |
| 2 | 14592 | |
| 3 | 11359 | |
| 4 | 9857 | |
| 5 | 8767 | |
| 6 | 7658 | 8.1% |
| 7 | 6521 | 6.9% |
| 8 | 5817 | 6.2% |
| 9 | 5242 | 5.6% |
| 0 | 5175 | 5.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| % | 309 | |
| : | 94 | 20.8% |
| ? | 29 | 6.4% |
| , | 10 | 2.2% |
| / | 6 | 1.3% |
| & | 4 | 0.9% |
| . | 1 | 0.2% |
Other Symbol
| Value | Count | Frequency (%) |
| ❤ | 5 | |
|  | 1 | 11.1% |
| ♂ | 1 | 11.1% |
| ♀ | 1 | 11.1% |
| ⛑ | 1 | 11.1% |
Space Separator
| Value | Count | Frequency (%) |
| 2084 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 310 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 106 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 105 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 39 |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ️ | 7 |
Format
| Value | Count | Frequency (%) |
| | 2 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 97273 | |
| Latin | 76309 | |
| Inherited | 9 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 20477 | |
| K | 12119 | |
| N | 9147 | |
| B | 8255 | |
| L | 3754 | 4.9% |
| e | 2989 | 3.9% |
| a | 2813 | 3.7% |
| r | 2133 | 2.8% |
| t | 1748 | 2.3% |
| i | 1445 | 1.9% |
| Other values (47) | 11429 |
Common
| Value | Count | Frequency (%) |
| 1 | 19178 | |
| 2 | 14592 | |
| 3 | 11359 | |
| 4 | 9857 | |
| 5 | 8767 | |
| 6 | 7658 | 7.9% |
| 7 | 6521 | 6.7% |
| 8 | 5817 | 6.0% |
| 9 | 5242 | 5.4% |
| 0 | 5175 | 5.3% |
| Other values (18) | 3107 | 3.2% |
Inherited
| Value | Count | Frequency (%) |
| ️ | 7 | |
| | 2 | 22.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 173547 | |
| None | 25 | < 0.1% |
| VS | 7 | < 0.1% |
| Dingbats | 5 | < 0.1% |
| Punctuation | 3 | < 0.1% |
| Misc Symbols | 3 | < 0.1% |
| Specials | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 20477 | 11.8% |
| 1 | 19178 | 11.1% |
| 2 | 14592 | 8.4% |
| K | 12119 | 7.0% |
| 3 | 11359 | 6.5% |
| 4 | 9857 | 5.7% |
| N | 9147 | 5.3% |
| 5 | 8767 | 5.1% |
| B | 8255 | 4.8% |
| 6 | 7658 | 4.4% |
| Other values (64) | 52138 |
None
| Value | Count | Frequency (%) |
| é | 20 | |
| î | 2 | 8.0% |
| ï | 1 | 4.0% |
| ë | 1 | 4.0% |
| à | 1 | 4.0% |
VS
| Value | Count | Frequency (%) |
| ️ | 7 |
Dingbats
| Value | Count | Frequency (%) |
| ❤ | 5 |
Punctuation
| Value | Count | Frequency (%) |
| | 2 | |
| ’ | 1 |
Specials
| Value | Count | Frequency (%) |
|  | 1 |
Misc Symbols
| Value | Count | Frequency (%) |
| ♂ | 1 | |
| ♀ | 1 | |
| ⛑ | 1 |
dim_status
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 916.6 KiB |
| CLOSED | |
|---|---|
| IN_PROGRESS | 365 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.0155579 |
| Min length | 6 |
Characters and Unicode
| Total characters | 705649 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CLOSED |
|---|---|
| 2nd row | CLOSED |
| 3rd row | CLOSED |
| 4th row | CLOSED |
| 5th row | CLOSED |
Common Values
| Value | Count | Frequency (%) |
| CLOSED | 116939 | |
| IN_PROGRESS | 365 | 0.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| closed | 116939 | |
| in_progress | 365 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 117669 | |
| O | 117304 | |
| E | 117304 | |
| C | 116939 | |
| L | 116939 | |
| D | 116939 | |
| R | 730 | 0.1% |
| I | 365 | 0.1% |
| N | 365 | 0.1% |
| _ | 365 | 0.1% |
| Other values (2) | 730 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 705284 | |
| Connector Punctuation | 365 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 117669 | |
| O | 117304 | |
| E | 117304 | |
| C | 116939 | |
| L | 116939 | |
| D | 116939 | |
| R | 730 | 0.1% |
| I | 365 | 0.1% |
| N | 365 | 0.1% |
| P | 365 | 0.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 365 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 705284 | |
| Common | 365 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 117669 | |
| O | 117304 | |
| E | 117304 | |
| C | 116939 | |
| L | 116939 | |
| D | 116939 | |
| R | 730 | 0.1% |
| I | 365 | 0.1% |
| N | 365 | 0.1% |
| P | 365 | 0.1% |
Common
| Value | Count | Frequency (%) |
| _ | 365 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 705649 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 117669 | |
| O | 117304 | |
| E | 117304 | |
| C | 116939 | |
| L | 116939 | |
| D | 116939 | |
| R | 730 | 0.1% |
| I | 365 | 0.1% |
| N | 365 | 0.1% |
| _ | 365 | 0.1% |
| Other values (2) | 730 | 0.1% |
dim_type
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 916.6 KiB |
| 1 | |
|---|---|
| 3 | 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 117304 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 117301 | |
| 3 | 3 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 117301 | |
| 3 | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 117301 | |
| 3 | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 117304 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 117301 | |
| 3 | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 117304 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 117301 | |
| 3 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 117304 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 117301 | |
| 3 | 3 | < 0.1% |
dim_comment
Categorical
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 117210 |
| Missing (%) | 99.9% |
| Memory size | 916.6 KiB |
| Delivery |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 752 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Delivery |
|---|---|
| 2nd row | Delivery |
| 3rd row | Delivery |
| 4th row | Delivery |
| 5th row | Delivery |
Common Values
| Value | Count | Frequency (%) |
| Delivery | 94 | 0.1% |
| (Missing) | 117210 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivery | 94 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 188 | |
| D | 94 | |
| l | 94 | |
| i | 94 | |
| v | 94 | |
| r | 94 | |
| y | 94 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 658 | |
| Uppercase Letter | 94 | 12.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 188 | |
| l | 94 | |
| i | 94 | |
| v | 94 | |
| r | 94 | |
| y | 94 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 94 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 752 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 188 | |
| D | 94 | |
| l | 94 | |
| i | 94 | |
| v | 94 | |
| r | 94 | |
| y | 94 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 752 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 188 | |
| D | 94 | |
| l | 94 | |
| i | 94 | |
| v | 94 | |
| r | 94 | |
| y | 94 |
dim_source
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 916.6 KiB |
| Tiller iPAD | |
|---|---|
| tiller-order | |
| LAFOURCHETTE | 326 |
| other | 166 |
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 11.453974 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1343597 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Tiller iPAD |
|---|---|
| 2nd row | Tiller iPAD |
| 3rd row | Tiller iPAD |
| 4th row | tiller-order |
| 5th row | Tiller iPAD |
Common Values
| Value | Count | Frequency (%) |
| Tiller iPAD | 62889 | |
| tiller-order | 53923 | |
| LAFOURCHETTE | 326 | 0.3% |
| other | 166 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| tiller | 62889 | |
| ipad | 62889 | |
| tiller-order | 53923 | |
| lafourchette | 326 | 0.2% |
| other | 166 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 233624 | |
| r | 224824 | |
| i | 179701 | |
| e | 170901 | |
| T | 63541 | 4.7% |
| A | 63215 | 4.7% |
| 62889 | 4.7% | |
| P | 62889 | 4.7% |
| D | 62889 | 4.7% |
| o | 54089 | 4.0% |
| Other values (12) | 165035 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 971317 | |
| Uppercase Letter | 255468 | 19.0% |
| Space Separator | 62889 | 4.7% |
| Dash Punctuation | 53923 | 4.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 63541 | |
| A | 63215 | |
| P | 62889 | |
| D | 62889 | |
| E | 652 | 0.3% |
| L | 326 | 0.1% |
| F | 326 | 0.1% |
| O | 326 | 0.1% |
| U | 326 | 0.1% |
| R | 326 | 0.1% |
| Other values (2) | 652 | 0.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 233624 | |
| r | 224824 | |
| i | 179701 | |
| e | 170901 | |
| o | 54089 | 5.6% |
| t | 54089 | 5.6% |
| d | 53923 | 5.6% |
| h | 166 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 62889 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 53923 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1226785 | |
| Common | 116812 | 8.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 233624 | |
| r | 224824 | |
| i | 179701 | |
| e | 170901 | |
| T | 63541 | 5.2% |
| A | 63215 | 5.2% |
| P | 62889 | 5.1% |
| D | 62889 | 5.1% |
| o | 54089 | 4.4% |
| t | 54089 | 4.4% |
| Other values (10) | 57023 | 4.6% |
Common
| Value | Count | Frequency (%) |
| 62889 | ||
| - | 53923 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1343597 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 233624 | |
| r | 224824 | |
| i | 179701 | |
| e | 170901 | |
| T | 63541 | 4.7% |
| A | 63215 | 4.7% |
| 62889 | 4.7% | |
| P | 62889 | 4.7% |
| D | 62889 | 4.7% |
| o | 54089 | 4.0% |
| Other values (12) | 165035 |
m_nb_customer
Real number (ℝ)
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3795693 |
| Minimum | 0 |
|---|---|
| Maximum | 62 |
| Zeros | 356 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 62 |
| Range | 62 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.1540088 |
|---|---|
| Coefficient of variation (CV) | 0.83649935 |
| Kurtosis | 311.56946 |
| Mean | 1.3795693 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.000394 |
| Sum | 161829 |
| Variance | 1.3317364 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=40)
| Value | Count | Frequency (%) |
| 1 | 92439 | |
| 2 | 16176 | 13.8% |
| 3 | 3273 | 2.8% |
| 4 | 2565 | 2.2% |
| 5 | 1071 | 0.9% |
| 6 | 622 | 0.5% |
| 0 | 356 | 0.3% |
| 7 | 275 | 0.2% |
| 8 | 192 | 0.2% |
| 9 | 108 | 0.1% |
| Other values (30) | 227 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 356 | 0.3% |
| 1 | 92439 | |
| 2 | 16176 | 13.8% |
| 3 | 3273 | 2.8% |
| 4 | 2565 | 2.2% |
| 5 | 1071 | 0.9% |
| 6 | 622 | 0.5% |
| 7 | 275 | 0.2% |
| 8 | 192 | 0.2% |
| 9 | 108 | 0.1% |
| Value | Count | Frequency (%) |
| 62 | 1 | |
| 60 | 1 | |
| 50 | 1 | |
| 49 | 1 | |
| 48 | 1 | |
| 42 | 1 | |
| 40 | 2 | |
| 36 | 1 | |
| 35 | 2 | |
| 32 | 2 |
m_cached_payed
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 3969 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.294191 |
| Minimum | 0 |
|---|---|
| Maximum | 11512.5 |
| Zeros | 732 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 11.8 |
| median | 14.1 |
| Q3 | 30 |
| 95-th percentile | 117 |
| Maximum | 11512.5 |
| Range | 11512.5 |
| Interquartile range (IQR) | 18.2 |
Descriptive statistics
| Standard deviation | 111.24697 |
|---|---|
| Coefficient of variation (CV) | 2.9050612 |
| Kurtosis | 1176.2049 |
| Mean | 38.294191 |
| Median Absolute Deviation (MAD) | 4.6 |
| Skewness | 20.408436 |
| Sum | 4492061.8 |
| Variance | 12375.888 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 12950 | 11.0% |
| 12.9 | 5319 | 4.5% |
| 16 | 3391 | 2.9% |
| 9.5 | 3357 | 2.9% |
| 9 | 3053 | 2.6% |
| 9.9 | 3022 | 2.6% |
| 11 | 2397 | 2.0% |
| 13.5 | 2117 | 1.8% |
| 12 | 1926 | 1.6% |
| 18 | 1773 | 1.5% |
| Other values (3959) | 77999 |
| Value | Count | Frequency (%) |
| 0 | 732 | |
| 0.02 | 4 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.35 | 1 | < 0.1% |
| 0.4 | 4 | < 0.1% |
| 0.45 | 1 | < 0.1% |
| 0.5 | 41 | < 0.1% |
| 0.56 | 1 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11512.5 | 1 | |
| 5504.2 | 1 | |
| 3631.5 | 1 | |
| 3550.5 | 1 | |
| 3017.5 | 1 | |
| 3000 | 1 | |
| 2895.5 | 1 | |
| 2830 | 1 | |
| 2778 | 1 | |
| 2740 | 1 |
m_cached_price
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 3968 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.298951 |
| Minimum | 0 |
|---|---|
| Maximum | 11512.5 |
| Zeros | 699 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 916.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 11.8 |
| median | 14.1 |
| Q3 | 30 |
| 95-th percentile | 117 |
| Maximum | 11512.5 |
| Range | 11512.5 |
| Interquartile range (IQR) | 18.2 |
Descriptive statistics
| Standard deviation | 111.24241 |
|---|---|
| Coefficient of variation (CV) | 2.9045811 |
| Kurtosis | 1176.3944 |
| Mean | 38.298951 |
| Median Absolute Deviation (MAD) | 4.6 |
| Skewness | 20.410679 |
| Sum | 4492620.2 |
| Variance | 12374.874 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 12952 | 11.0% |
| 12.9 | 5319 | 4.5% |
| 16 | 3392 | 2.9% |
| 9.5 | 3357 | 2.9% |
| 9 | 3053 | 2.6% |
| 9.9 | 3022 | 2.6% |
| 11 | 2397 | 2.0% |
| 13.5 | 2117 | 1.8% |
| 12 | 1926 | 1.6% |
| 18 | 1773 | 1.5% |
| Other values (3958) | 77996 |
| Value | Count | Frequency (%) |
| 0 | 699 | |
| 0.02 | 4 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.35 | 1 | < 0.1% |
| 0.4 | 4 | < 0.1% |
| 0.45 | 1 | < 0.1% |
| 0.5 | 41 | < 0.1% |
| 0.56 | 1 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11512.5 | 1 | |
| 5504.2 | 1 | |
| 3631.5 | 1 | |
| 3550.5 | 1 | |
| 3017.5 | 1 | |
| 3000 | 1 | |
| 2895.5 | 1 | |
| 2830 | 1 | |
| 2778 | 1 | |
| 2740 | 1 |
| id_order | id_store | id_table | id_waiter | id_customer | id_device | m_nb_customer | m_cached_payed | m_cached_price | dim_status | dim_type | dim_source | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id_order | 1.000 | 0.261 | 0.257 | 0.384 | 0.422 | 0.215 | 0.118 | 0.108 | 0.108 | 0.048 | 0.015 | 0.304 |
| id_store | 0.261 | 1.000 | 0.955 | 1.000 | 0.104 | 0.341 | 0.320 | 0.423 | 0.423 | 0.199 | 0.012 | 0.480 |
| id_table | 0.257 | 0.955 | 1.000 | 0.897 | 0.635 | 0.957 | 0.080 | -0.031 | -0.031 | 0.020 | 0.000 | 0.483 |
| id_waiter | 0.384 | 1.000 | 0.897 | 1.000 | 0.001 | 0.106 | 0.128 | 0.352 | 0.353 | 0.084 | 1.000 | 0.655 |
| id_customer | 0.422 | 0.104 | 0.635 | 0.001 | 1.000 | 0.260 | -0.010 | 0.057 | 0.057 | 0.401 | 0.267 | 0.426 |
| id_device | 0.215 | 0.341 | 0.957 | 0.106 | 0.260 | 1.000 | 0.200 | 0.067 | 0.067 | 0.016 | 0.005 | 0.530 |
| m_nb_customer | 0.118 | 0.320 | 0.080 | 0.128 | -0.010 | 0.200 | 1.000 | 0.500 | 0.499 | 0.013 | 0.000 | 0.028 |
| m_cached_payed | 0.108 | 0.423 | -0.031 | 0.352 | 0.057 | 0.067 | 0.500 | 1.000 | 0.999 | 0.000 | 0.000 | 0.022 |
| m_cached_price | 0.108 | 0.423 | -0.031 | 0.353 | 0.057 | 0.067 | 0.499 | 0.999 | 1.000 | 0.000 | 0.000 | 0.022 |
| dim_status | 0.048 | 0.199 | 0.020 | 0.084 | 0.401 | 0.016 | 0.013 | 0.000 | 0.000 | 1.000 | 0.000 | 0.811 |
| dim_type | 0.015 | 0.012 | 0.000 | 1.000 | 0.267 | 0.005 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.044 |
| dim_source | 0.304 | 0.480 | 0.483 | 0.655 | 0.426 | 0.530 | 0.028 | 0.022 | 0.022 | 0.811 | 0.044 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| id_order | id_store | id_table | id_waiter | id_customer | id_external | id_device | date_opened | date_closed | dim_name | dim_status | dim_type | dim_comment | dim_source | m_nb_customer | m_cached_payed | m_cached_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 55538867 | 8052 | NaN | NaN | NaN | 0425716B-EFF4-41CA-AEA1-839104F36833 | 15327.0 | 2019-01-12 13:02:17+00:00 | 2019-01-12 19:58:38+00:00 | vincent | CLOSED | 1 | NaN | Tiller iPAD | 1 | 45.5 | 45.5 |
| 1 | 56035309 | 8052 | NaN | NaN | NaN | 75E41FE2-64FF-41D3-954C-A7DE4AA887EF | 15327.0 | 2019-01-16 19:39:09+00:00 | 2019-01-16 22:10:50+00:00 | frere et soeur avec pierre | CLOSED | 1 | NaN | Tiller iPAD | 2 | 49.8 | 49.8 |
| 2 | 55550051 | 8052 | NaN | NaN | NaN | F6051A05-C9AC-4033-BF72-BB5149B8F439 | 15327.0 | 2019-01-12 14:18:46+00:00 | 2019-01-12 19:50:32+00:00 | rachel | CLOSED | 1 | NaN | Tiller iPAD | 1 | 27.4 | 27.4 |
| 3 | 57000119 | 8052 | NaN | 16199.0 | NaN | B8BEEC66-1C10-48A0-B4D5-035CB5EEFE62 | 15327.0 | 2019-01-24 17:49:12+00:00 | 2019-01-24 21:58:59+00:00 | Groupe PEL | CLOSED | 1 | NaN | tiller-order | 3 | 60.0 | 60.0 |
| 4 | 55558817 | 8052 | NaN | NaN | NaN | 17F0533C-2FF1-4FC5-A50D-12704C7B7A4B | 15327.0 | 2019-01-12 15:25:06+00:00 | 2019-01-12 19:21:03+00:00 | remi et date | CLOSED | 1 | NaN | Tiller iPAD | 2 | 39.9 | 39.9 |
| 5 | 55451477 | 8052 | NaN | NaN | NaN | 570F71DE-504D-4040-BE10-19B5FDF64FAD | 15327.0 | 2019-01-11 19:13:15+00:00 | 2019-01-11 23:22:04+00:00 | abdel | CLOSED | 1 | NaN | Tiller iPAD | 1 | 25.0 | 25.0 |
| 6 | 56030563 | 8052 | NaN | NaN | NaN | 0BEB2A9B-4A3A-4BEE-AC13-8BDCB03DF568 | 15327.0 | 2019-01-16 19:04:08+00:00 | 2019-01-16 22:13:55+00:00 | pierre + 6 | CLOSED | 1 | NaN | Tiller iPAD | 7 | 220.7 | 220.7 |
| 7 | 56310086 | 8052 | NaN | NaN | NaN | 5522AFFD-BC4A-4F24-8129-14400BC529AA | 15327.0 | 2019-01-18 19:06:17+00:00 | 2019-01-18 23:13:08+00:00 | oceane +3 | CLOSED | 1 | NaN | Tiller iPAD | 4 | 111.0 | 111.0 |
| 8 | 54326699 | 8052 | NaN | NaN | NaN | E41B347F-840F-4067-90F4-76D3E5258A2B | 15327.0 | 2019-01-01 16:33:33+00:00 | 2019-01-01 23:47:28+00:00 | margaux, agathe et melanie | CLOSED | 1 | NaN | Tiller iPAD | 3 | 41.0 | 41.0 |
| 9 | 56479526 | 8052 | NaN | NaN | NaN | B47CEA06-6AD3-406D-81F1-92DA56500267 | 15327.0 | 2019-01-19 21:44:00+00:00 | 2019-01-19 23:15:16+00:00 | filles canapé | CLOSED | 1 | NaN | Tiller iPAD | 3 | 33.9 | 33.9 |
| id_order | id_store | id_table | id_waiter | id_customer | id_external | id_device | date_opened | date_closed | dim_name | dim_status | dim_type | dim_comment | dim_source | m_nb_customer | m_cached_payed | m_cached_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117294 | 127644032 | 4542 | NaN | 7588.0 | NaN | D85D8798-294A-4E7C-8E2A-EB04E11D3C45 | 7411.0 | 2020-06-11 10:24:51+00:00 | 2020-06-11 10:25:37+00:00 | A8 | CLOSED | 1 | NaN | tiller-order | 1 | 32.0 | 32.0 |
| 117295 | 107406512 | 4542 | NaN | 7588.0 | NaN | D921B715-5611-451B-BF95-31797FEB05DC | 7411.0 | 2019-12-09 11:17:58+00:00 | 2019-12-09 11:18:24+00:00 | A8 | CLOSED | 1 | NaN | tiller-order | 1 | 29.0 | 29.0 |
| 117296 | 109108534 | 4542 | NaN | 7588.0 | NaN | 03ED1712-0D8F-4282-8504-A01964E5A092 | 7411.0 | 2019-12-19 11:34:27+00:00 | 2019-12-19 11:36:12+00:00 | A11 | CLOSED | 1 | NaN | tiller-order | 1 | 49.0 | 49.0 |
| 117297 | 127788783 | 4542 | NaN | 7588.0 | NaN | 29291CDC-7D3E-48BE-AFD0-269ADAFFCFFD | 7411.0 | 2020-06-12 10:47:26+00:00 | 2020-06-12 10:47:59+00:00 | A15 | CLOSED | 1 | NaN | tiller-order | 1 | 25.0 | 25.0 |
| 117298 | 111677485 | 4542 | NaN | 7588.0 | NaN | 5361A0BE-AAD3-4339-8DAE-7F2BB46E0D67 | 7411.0 | 2020-01-07 12:01:49+00:00 | 2020-01-07 12:03:50+00:00 | A37 | CLOSED | 1 | NaN | tiller-order | 1 | 26.0 | 26.0 |
| 117299 | 61630471 | 4542 | NaN | NaN | NaN | C4A0AFD8-FBD7-4740-A48B-4890F46E43E2 | 7411.0 | 2019-02-28 13:13:21+00:00 | 2019-02-28 13:38:45+00:00 | NaN | CLOSED | 1 | NaN | Tiller iPAD | 1 | 23.0 | 23.0 |
| 117300 | 76772730 | 4542 | NaN | NaN | NaN | 95A17B0B-22AE-43A1-8BEB-B105BF337655 | 7411.0 | 2019-06-11 11:08:01+00:00 | 2019-06-11 11:10:26+00:00 | NaN | CLOSED | 1 | NaN | Tiller iPAD | 1 | 26.0 | 26.0 |
| 117301 | 77799227 | 4542 | NaN | NaN | NaN | 0E5D4843-7EA3-4D9E-9490-EB9717A0220F | 7411.0 | 2019-06-17 10:30:50+00:00 | 2019-06-17 10:32:45+00:00 | NaN | CLOSED | 1 | NaN | Tiller iPAD | 1 | 29.0 | 29.0 |
| 117302 | 60627160 | 4542 | NaN | NaN | NaN | CE760A3B-4464-462A-AA2C-CCFEB88EEC39 | 7411.0 | 2019-02-21 11:50:58+00:00 | 2019-02-21 11:51:56+00:00 | NaN | CLOSED | 1 | NaN | Tiller iPAD | 1 | 32.0 | 32.0 |
| 117303 | 93223821 | 4542 | NaN | NaN | NaN | F004A307-C7C9-4508-A587-49ED5CF8F156 | 7411.0 | 2019-09-18 11:32:35+00:00 | 2019-09-18 11:39:38+00:00 | NaN | CLOSED | 1 | NaN | Tiller iPAD | 1 | 17.0 | 17.0 |